You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
MAZATLANIA HESPERIA |
5.00 | |
HAUSTELLUM TWEEDIANUS |
12.00 | |
NASSARIUS POLYGONATUS |
3.00 | |
CYMBOVULA DEFLEXA |
6.00 | |
CYMBIOLA VESPERTILIO |
6.00 | |
NOTOPEPLUM SERICATUM |
30.00 | |
CERION cf. AGRESTINA |
6.00 | |
CORCULUM CARDISSA IMPRESSUM |
6.00 | |
BOLMA BARTSCHI |
12.00 | |
FUSOLATIRUS RIKAE |
15.00 | |
TIVELA MACTROIDES |
4.00 | |
ARCINELLA ARCINELLA |
12.00 | |
EXCELLICHLAMYS SPECTABILIS |
3.00 | |
MAZATLANIA HESPERIA |
4.00 | |
ANNACHLAMYS KUHNHOLTZI |
8.00 | |
MELONGENA MELONGENA |
25.00 | |
LIENARDIA PLANILABRUM |
8.00 | |
NANINA CITRINA |
8.00 | |
CORCULUM CARDISSA |
6.00 | |
CANTHARUS ELEGANS |
6.00 | |
ERRONEA ERRONES NIGER |
25.00 | |
ANACHIS CORONATA |
3.00 | |
VASTICARDIUM KENYANUM |
15.00 | |
TEREBRA ARGUS |
4.00 | |
MAZATLANIA HESPERIA |
3.00 | |
CONUS SURATENSIS |
25.00 | |
MAZATLANIA HESPERIA |
3.00 | |
CONUS PICA |
12.00 | |
BABELOMUREX SPINOSUS |
35.00 | |
CHICOREUS AXICORNIS |
6.00 | |
Total: | 316.00 |